Airbnb Booking

Dataset statistics

Number of variables	30
Number of observations	546279
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	87775
Duplicate rows (%)	16.1%
Total size in memory	125.0 MiB
Average record size in memory	240.0 B

Variable types

Numeric	19
Categorical	11

Alerts

Dataset has 87775 (16.1%) duplicate rows	Duplicates
`days_from_first_active_until_booking` is highly correlated with `days_from_account_created_until_first_booking`	High correlation
`days_from_account_created_until_first_booking` is highly correlated with `days_from_first_active_until_booking`	High correlation
`year_first_active` is highly correlated with `year_first_booking` and 1 other fields	High correlation
`month_first_active` is highly correlated with `week_of_year_first_active` and 4 other fields	High correlation
`day_first_active` is highly correlated with `day_account_created`	High correlation
`day_of_week_first_active` is highly correlated with `day_of_week_account_created`	High correlation
`week_of_year_first_active` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_first_booking` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`week_of_year_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_account_created` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`day_account_created` is highly correlated with `day_first_active`	High correlation
`day_of_week_account_created` is highly correlated with `day_of_week_first_active`	High correlation
`week_of_year_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`days_from_first_active_until_booking` is highly correlated with `days_from_account_created_until_first_booking` and 1 other fields	High correlation
`days_from_account_created_until_first_booking` is highly correlated with `days_from_first_active_until_booking` and 1 other fields	High correlation
`year_first_active` is highly correlated with `year_first_booking` and 1 other fields	High correlation
`month_first_active` is highly correlated with `week_of_year_first_active` and 4 other fields	High correlation
`day_first_active` is highly correlated with `day_account_created`	High correlation
`day_of_week_first_active` is highly correlated with `day_of_week_account_created`	High correlation
`week_of_year_first_active` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_first_booking` is highly correlated with `days_from_first_active_until_booking` and 3 other fields	High correlation
`month_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`week_of_year_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_account_created` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`day_account_created` is highly correlated with `day_first_active`	High correlation
`day_of_week_account_created` is highly correlated with `day_of_week_first_active`	High correlation
`week_of_year_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`days_from_first_active_until_booking` is highly correlated with `days_from_account_created_until_first_booking`	High correlation
`days_from_account_created_until_first_booking` is highly correlated with `days_from_first_active_until_booking`	High correlation
`year_first_active` is highly correlated with `year_first_booking` and 1 other fields	High correlation
`month_first_active` is highly correlated with `week_of_year_first_active` and 4 other fields	High correlation
`day_first_active` is highly correlated with `day_account_created`	High correlation
`day_of_week_first_active` is highly correlated with `day_of_week_account_created`	High correlation
`week_of_year_first_active` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_first_booking` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`week_of_year_first_booking` is highly correlated with `month_first_active` and 4 other fields	High correlation
`year_account_created` is highly correlated with `year_first_active` and 1 other fields	High correlation
`month_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`day_account_created` is highly correlated with `day_first_active`	High correlation
`day_of_week_account_created` is highly correlated with `day_of_week_first_active`	High correlation
`week_of_year_account_created` is highly correlated with `month_first_active` and 4 other fields	High correlation
`affiliate_provider` is highly correlated with `affiliate_channel`	High correlation
`first_browser` is highly correlated with `first_device_type`	High correlation
`signup_app` is highly correlated with `first_device_type`	High correlation
`affiliate_channel` is highly correlated with `affiliate_provider`	High correlation
`first_device_type` is highly correlated with `first_browser` and 1 other fields	High correlation
`signup_flow` is highly correlated with `affiliate_channel` and 3 other fields	High correlation
`days_from_first_active_until_booking` is highly correlated with `days_from_account_created_until_first_booking` and 5 other fields	High correlation
`days_from_account_created_until_first_booking` is highly correlated with `days_from_first_active_until_booking` and 7 other fields	High correlation
`year_first_active` is highly correlated with `days_from_account_created_until_first_booking` and 6 other fields	High correlation
`month_first_active` is highly correlated with `year_first_active` and 6 other fields	High correlation
`day_first_active` is highly correlated with `day_first_booking` and 1 other fields	High correlation
`day_of_week_first_active` is highly correlated with `day_of_week_account_created`	High correlation
`week_of_year_first_active` is highly correlated with `year_first_active` and 6 other fields	High correlation
`year_first_booking` is highly correlated with `days_from_first_active_until_booking` and 7 other fields	High correlation
`month_first_booking` is highly correlated with `days_from_first_active_until_booking` and 7 other fields	High correlation
`day_first_booking` is highly correlated with `days_from_first_active_until_booking` and 6 other fields	High correlation
`week_of_year_first_booking` is highly correlated with `days_from_first_active_until_booking` and 9 other fields	High correlation
`year_account_created` is highly correlated with `days_from_account_created_until_first_booking` and 6 other fields	High correlation
`month_account_created` is highly correlated with `year_first_active` and 6 other fields	High correlation
`day_account_created` is highly correlated with `day_first_active` and 1 other fields	High correlation
`day_of_week_account_created` is highly correlated with `day_of_week_first_active`	High correlation
`week_of_year_account_created` is highly correlated with `year_first_active` and 6 other fields	High correlation
`affiliate_channel` is highly correlated with `signup_flow` and 3 other fields	High correlation
`affiliate_provider` is highly correlated with `signup_flow` and 2 other fields	High correlation
`first_affiliate_tracked` is highly correlated with `affiliate_channel` and 1 other fields	High correlation
`signup_app` is highly correlated with `signup_flow` and 3 other fields	High correlation
`first_device_type` is highly correlated with `signup_app` and 1 other fields	High correlation
`first_browser` is highly correlated with `signup_flow` and 2 other fields	High correlation
`country_destination` is highly correlated with `days_from_first_active_until_booking` and 4 other fields	High correlation
`days_from_first_active_until_account_created` is highly skewed (γ1 = 68.1409591)	Skewed
`signup_flow` has 434571 (79.6%) zeros	Zeros
`days_from_first_active_until_booking` has 120474 (22.1%) zeros	Zeros
`days_from_first_active_until_account_created` has 545277 (99.8%) zeros	Zeros
`days_from_account_created_until_first_booking` has 120411 (22.0%) zeros	Zeros
`day_of_week_first_active` has 85482 (15.6%) zeros	Zeros
`day_of_week_first_booking` has 122976 (22.5%) zeros	Zeros
`day_of_week_account_created` has 85435 (15.6%) zeros	Zeros

Reproduction

Analysis started	2021-10-23 04:53:08.152220
Analysis finished	2021-10-23 04:55:12.571403
Duration	2 minutes and 4.42 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

age
Real number (ℝ_≥0)

Distinct	99
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.78003548

Minimum	16
Maximum	115
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	16
5-th percentile	23
Q1	28
median	33
Q3	41
95-th percentile	61
Maximum	115
Range	99
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	13.19491544
Coefficient of variation (CV)	0.3587521129
Kurtosis	6.785259131
Mean	36.78003548
Median Absolute Deviation (MAD)	6
Skewness	2.111932589
Sum	20092161
Variance	174.1057934
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
31	29815	5.5%
30	29770	5.4%
29	28661	5.2%
32	28337	5.2%
28	26815	4.9%
33	26116	4.8%
27	24152	4.4%
34	23507	4.3%
35	21945	4.0%
26	21221	3.9%
Other values (89)	285940	52.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
16	26	< 0.1%
17	74	< 0.1%
18	1670	0.3%
19	3686	0.7%
20	2771	0.5%
21	4847	0.9%
22	8493	1.6%
23	11818	2.2%
24	14816	2.7%
25	18788	3.4%

Value	Count	Frequency (%)
115	12	< 0.1%
113	4	< 0.1%
112	1	< 0.1%
111	2	< 0.1%
110	191	< 0.1%
109	97	< 0.1%
108	83	< 0.1%
107	83	< 0.1%
106	71	< 0.1%
105	4099	0.8%

signup_flow
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.737092218

Minimum	0
Maximum	25
Zeros	434571
Zeros (%)	79.6%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	14
Maximum	25
Range	25
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	5.311753542
Coefficient of variation (CV)	3.057841999
Kurtosis	11.34789856
Mean	1.737092218
Median Absolute Deviation (MAD)	0
Skewness	3.506835154
Sum	948937
Variance	28.21472569
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
0	434571	79.6%
1	27888	5.1%
2	22776	4.2%
25	11426	2.1%
3	9877	1.8%
12	8243	1.5%
24	6559	1.2%
23	2831	0.5%
5	2086	0.4%
6	2005	0.4%
Other values (16)	18017	3.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	434571	79.6%
1	27888	5.1%
2	22776	4.2%
3	9877	1.8%
4	1984	0.4%
5	2086	0.4%
6	2005	0.4%
7	1799	0.3%
8	1819	0.3%
9	1621	0.3%

Value	Count	Frequency (%)
25	11426	2.1%
24	6559	1.2%
23	2831	0.5%
22	796	0.1%
21	1046	0.2%
20	655	0.1%
19	716	0.1%
18	665	0.1%
17	703	0.1%
16	706	0.1%

days_from_first_active_until_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1853
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	116.4462738

Minimum	0
Maximum	2228
Zeros	120474
Zeros (%)	22.1%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	6
Q3	105
95-th percentile	675
Maximum	2228
Range	2228
Interquartile range (IQR)	104

Descriptive statistics

Standard deviation	241.585994
Coefficient of variation (CV)	2.074656286
Kurtosis	9.684070986
Mean	116.4462738
Median Absolute Deviation (MAD)	6
Skewness	2.960146322
Sum	63612154
Variance	58363.79247
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	120474	22.1%
1	69034	12.6%
2	32199	5.9%
3	20580	3.8%
4	15089	2.8%
5	11521	2.1%
6	10281	1.9%
7	8860	1.6%
8	7636	1.4%
9	6039	1.1%
Other values (1843)	244566	44.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	120474	22.1%
1	69034	12.6%
2	32199	5.9%
3	20580	3.8%
4	15089	2.8%
5	11521	2.1%
6	10281	1.9%
7	8860	1.6%
8	7636	1.4%
9	6039	1.1%

Value	Count	Frequency (%)
2228	1	< 0.1%
2001	2	< 0.1%
1999	1	< 0.1%
1995	1	< 0.1%
1992	1	< 0.1%
1991	2	< 0.1%
1990	2	< 0.1%
1980	1	< 0.1%
1979	1	< 0.1%
1977	1	< 0.1%

days_from_first_active_until_account_created
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	327
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.226173805

Minimum	0
Maximum	1456
Zeros	545277
Zeros (%)	99.8%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1456
Range	1456
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	10.19124704
Coefficient of variation (CV)	45.0593606
Kurtosis	5805.244583
Mean	0.226173805
Median Absolute Deviation (MAD)	0
Skewness	68.1409591
Sum	123554
Variance	103.8615162
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	545277	99.8%
2	103	< 0.1%
1	91	< 0.1%
3	67	< 0.1%
4	61	< 0.1%
5	15	< 0.1%
6	14	< 0.1%
13	12	< 0.1%
29	10	< 0.1%
10	9	< 0.1%
Other values (317)	620	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	545277	99.8%
1	91	< 0.1%
2	103	< 0.1%
3	67	< 0.1%
4	61	< 0.1%
5	15	< 0.1%
6	14	< 0.1%
7	5	< 0.1%
8	4	< 0.1%
9	8	< 0.1%

Value	Count	Frequency (%)
1456	1	< 0.1%
1369	1	< 0.1%
1361	1	< 0.1%
1148	1	< 0.1%
1036	1	< 0.1%
1011	1	< 0.1%
1006	1	< 0.1%
991	1	< 0.1%
984	1	< 0.1%
968	1	< 0.1%

days_from_account_created_until_first_booking
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1971
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	116.2196222

Minimum	-349
Maximum	2001
Zeros	120411
Zeros (%)	22.0%
Negative	232
Negative (%)	< 0.1%
Memory size	4.2 MiB

Quantile statistics

Minimum	-349
5-th percentile	0
Q1	1
median	6
Q3	104
95-th percentile	674
Maximum	2001
Range	2350
Interquartile range (IQR)	103

Descriptive statistics

Standard deviation	241.3262741
Coefficient of variation (CV)	2.07646755
Kurtosis	9.698711254
Mean	116.2196222
Median Absolute Deviation (MAD)	6
Skewness	2.962090965
Sum	63488339
Variance	58238.37059
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	120411	22.0%
1	68991	12.6%
2	32181	5.9%
3	20569	3.8%
4	15077	2.8%
5	11526	2.1%
6	10289	1.9%
7	8861	1.6%
8	7640	1.4%
9	6039	1.1%
Other values (1961)	244695	44.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-349	1	< 0.1%
-347	1	< 0.1%
-338	1	< 0.1%
-308	1	< 0.1%
-298	1	< 0.1%
-295	1	< 0.1%
-288	1	< 0.1%
-273	1	< 0.1%
-269	1	< 0.1%
-261	1	< 0.1%

Value	Count	Frequency (%)
2001	2	< 0.1%
1999	1	< 0.1%
1995	1	< 0.1%
1992	1	< 0.1%
1991	2	< 0.1%
1990	2	< 0.1%
1980	1	< 0.1%
1979	1	< 0.1%
1977	1	< 0.1%
1976	1	< 0.1%

year_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2012.696038

Minimum	2009
Maximum	2014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	2009
5-th percentile	2011
Q1	2012
median	2013
Q3	2013
95-th percentile	2014
Maximum	2014
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.9287412643
Coefficient of variation (CV)	0.0004614413934
Kurtosis	-0.3225380112
Mean	2012.696038
Median Absolute Deviation (MAD)	1
Skewness	-0.3714002799
Sum	1099493579
Variance	0.8625603361
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2013	220902	40.4%
2012	159773	29.2%
2014	110344	20.2%
2011	49170	9.0%
2010	6081	1.1%
2009	9	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2009	9	< 0.1%
2010	6081	1.1%
2011	49170	9.0%
2012	159773	29.2%
2013	220902	40.4%
2014	110344	20.2%

Value	Count	Frequency (%)
2014	110344	20.2%
2013	220902	40.4%
2012	159773	29.2%
2011	49170	9.0%
2010	6081	1.1%
2009	9	< 0.1%

month_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.806186948

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	5
Q3	8
95-th percentile	11
Maximum	12
Range	11
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.064040489
Coefficient of variation (CV)	0.5277199161
Kurtosis	-0.8653276745
Mean	5.806186948
Median Absolute Deviation (MAD)	2
Skewness	0.2761994348
Sum	3171798
Variance	9.38834412
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
5	74458	13.6%
6	70701	12.9%
4	61420	11.2%
3	51173	9.4%
2	45375	8.3%
8	43397	7.9%
1	43202	7.9%
9	40490	7.4%
7	33307	6.1%
10	32058	5.9%
Other values (2)	50698	9.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	43202	7.9%
2	45375	8.3%
3	51173	9.4%
4	61420	11.2%
5	74458	13.6%
6	70701	12.9%
7	33307	6.1%
8	43397	7.9%
9	40490	7.4%
10	32058	5.9%

Value	Count	Frequency (%)
12	19158	3.5%
11	31540	5.8%
10	32058	5.9%
9	40490	7.4%
8	43397	7.9%
7	33307	6.1%
6	70701	12.9%
5	74458	13.6%
4	61420	11.2%
3	51173	9.4%

day_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.51226388

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.42517705
Coefficient of variation (CV)	0.5431300754
Kurtosis	-1.179430597
Mean	15.51226388
Median Absolute Deviation (MAD)	7
Skewness	-0.0007476385669
Sum	8474024
Variance	70.98360832
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
24	20006	3.7%
22	19954	3.7%
23	19672	3.6%
27	19473	3.6%
13	19391	3.5%
16	19358	3.5%
3	19248	3.5%
15	19069	3.5%
10	18974	3.5%
21	18879	3.5%
Other values (21)	352255	64.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	12795	2.3%
2	16126	3.0%
3	19248	3.5%
4	18659	3.4%
5	18667	3.4%
6	18398	3.4%
7	18646	3.4%
8	18542	3.4%
9	18857	3.5%
10	18974	3.5%

Value	Count	Frequency (%)
31	2843	0.5%
30	11313	2.1%
29	14627	2.7%
28	17372	3.2%
27	19473	3.6%
26	18169	3.3%
25	18742	3.4%
24	20006	3.7%
23	19672	3.6%
22	19954	3.7%

day_of_week_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.44213671

Minimum	0
Maximum	6
Zeros	85482
Zeros (%)	15.6%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	4
95-th percentile	5
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.732002571
Coefficient of variation (CV)	0.7092160581
Kurtosis	-0.9209470515
Mean	2.44213671
Median Absolute Deviation (MAD)	1
Skewness	0.2732539292
Sum	1334088
Variance	2.999832906
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	105352	19.3%
1	103305	18.9%
3	93280	17.1%
0	85482	15.6%
4	77853	14.3%
5	57215	10.5%
6	23792	4.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	85482	15.6%
1	103305	18.9%
2	105352	19.3%
3	93280	17.1%
4	77853	14.3%
5	57215	10.5%
6	23792	4.4%

Value	Count	Frequency (%)
6	23792	4.4%
5	57215	10.5%
4	77853	14.3%
3	93280	17.1%
2	105352	19.3%
1	103305	18.9%
0	85482	15.6%

week_of_year_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.02255807

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	14
median	23
Q3	34
95-th percentile	48
Maximum	53
Range	52
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	13.29538283
Coefficient of variation (CV)	0.5534540823
Kurtosis	-0.8708825582
Mean	24.02255807
Median Absolute Deviation (MAD)	10
Skewness	0.2751285319
Sum	13123019
Variance	176.7672046
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23	18592	3.4%
21	17336	3.2%
25	17012	3.1%
19	16968	3.1%
20	16961	3.1%
24	16923	3.1%
26	16802	3.1%
18	15515	2.8%
22	15352	2.8%
17	14939	2.7%
Other values (43)	379879	69.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5764	1.1%
2	6395	1.2%
3	9919	1.8%
4	10171	1.9%
5	9358	1.7%
6	11323	2.1%
7	11283	2.1%
8	11470	2.1%
9	11266	2.1%
10	11789	2.2%

Value	Count	Frequency (%)
53	2	< 0.1%
52	3262	0.6%
51	5131	0.9%
50	6159	1.1%
49	6992	1.3%
48	6224	1.1%
47	7396	1.4%
46	8149	1.5%
45	8008	1.5%
44	6755	1.2%

year_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2013.005448

Minimum	2010
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	2010
5-th percentile	2011
Q1	2012
median	2013
Q3	2014
95-th percentile	2015
Maximum	2015
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.115803619
Coefficient of variation (CV)	0.0005542973666
Kurtosis	-0.3914133732
Mean	2013.005448
Median Absolute Deviation (MAD)	1
Skewness	0.002770402015
Sum	1099662603
Variance	1.245017715
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2013	199068	36.4%
2012	134766	24.7%
2014	109683	20.1%
2015	59628	10.9%
2011	38205	7.0%
2010	4929	0.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2010	4929	0.9%
2011	38205	7.0%
2012	134766	24.7%
2013	199068	36.4%
2014	109683	20.1%
2015	59628	10.9%

Value	Count	Frequency (%)
2015	59628	10.9%
2014	109683	20.1%
2013	199068	36.4%
2012	134766	24.7%
2011	38205	7.0%
2010	4929	0.9%

month_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.896624252

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	6
Q3	8
95-th percentile	11
Maximum	12
Range	11
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.78863546
Coefficient of variation (CV)	0.4729206646
Kurtosis	-0.5811415308
Mean	5.896624252
Median Absolute Deviation (MAD)	2
Skewness	0.2078363938
Sum	3221202
Variance	7.776487731
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
6	122412	22.4%
5	66871	12.2%
4	51430	9.4%
3	44936	8.2%
8	42984	7.9%
7	39742	7.3%
2	39337	7.2%
9	37727	6.9%
1	32093	5.9%
10	29770	5.4%
Other values (2)	38977	7.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	32093	5.9%
2	39337	7.2%
3	44936	8.2%
4	51430	9.4%
5	66871	12.2%
6	122412	22.4%
7	39742	7.3%
8	42984	7.9%
9	37727	6.9%
10	29770	5.4%

Value	Count	Frequency (%)
12	13024	2.4%
11	25953	4.8%
10	29770	5.4%
9	37727	6.9%
8	42984	7.9%
7	39742	7.3%
6	122412	22.4%
5	66871	12.2%
4	51430	9.4%
3	44936	8.2%

day_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.58056964

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	9
median	17
Q3	25
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	8.890933776
Coefficient of variation (CV)	0.5362260749
Kurtosis	-1.250846033
Mean	16.58056964
Median Absolute Deviation (MAD)	8
Skewness	-0.0815341159
Sum	9057617
Variance	79.0487034
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
29	66746	12.2%
15	18369	3.4%
16	18127	3.3%
5	18061	3.3%
17	17815	3.3%
23	17738	3.2%
11	17555	3.2%
4	17546	3.2%
9	17401	3.2%
13	17363	3.2%
Other values (21)	319558	58.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	12871	2.4%
2	14764	2.7%
3	16673	3.1%
4	17546	3.2%
5	18061	3.3%
6	16794	3.1%
7	16317	3.0%
8	16438	3.0%
9	17401	3.2%
10	16944	3.1%

Value	Count	Frequency (%)
31	2028	0.4%
30	7800	1.4%
29	66746	12.2%
28	14067	2.6%
27	14972	2.7%
26	15497	2.8%
25	17109	3.1%
24	17242	3.2%
23	17738	3.2%
22	17196	3.1%

day_of_week_first_booking
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.198726292

Minimum	0
Maximum	6
Zeros	122976
Zeros (%)	22.5%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	4
95-th percentile	5
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.740718929
Coefficient of variation (CV)	0.7916942348
Kurtosis	-0.9350392808
Mean	2.198726292
Median Absolute Deviation (MAD)	1
Skewness	0.3442726796
Sum	1201118
Variance	3.030102391
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	122976	22.5%
2	99818	18.3%
1	95110	17.4%
3	89558	16.4%
4	72818	13.3%
5	49568	9.1%
6	16431	3.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	122976	22.5%
1	95110	17.4%
2	99818	18.3%
3	89558	16.4%
4	72818	13.3%
5	49568	9.1%
6	16431	3.0%

Value	Count	Frequency (%)
6	16431	3.0%
5	49568	9.1%
4	72818	13.3%
3	89558	16.4%
2	99818	18.3%
1	95110	17.4%
0	122976	22.5%

week_of_year_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	52
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.66208476

Minimum	1
Maximum	52
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	16
median	25
Q3	33
95-th percentile	46
Maximum	52
Range	51
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	12.15744672
Coefficient of variation (CV)	0.4929610305
Kurtosis	-0.6199561973
Mean	24.66208476
Median Absolute Deviation (MAD)	9
Skewness	0.1555659313
Sum	13472379
Variance	147.8035107
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27	66130	12.1%
24	17404	3.2%
23	16869	3.1%
21	16335	3.0%
25	15682	2.9%
26	15175	2.8%
20	14801	2.7%
19	14599	2.7%
22	13686	2.5%
18	13617	2.5%
Other values (42)	341981	62.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	4045	0.7%
2	4745	0.9%
3	7661	1.4%
4	7974	1.5%
5	7177	1.3%
6	9017	1.7%
7	9476	1.7%
8	10118	1.9%
9	9806	1.8%
10	10369	1.9%

Value	Count	Frequency (%)
52	1775	0.3%
51	3854	0.7%
50	4770	0.9%
49	5604	1.0%
48	5099	0.9%
47	5790	1.1%
46	6480	1.2%
45	6863	1.3%
44	5632	1.0%
43	6086	1.1%

year_account_created
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

2013	220953
2012	159786
2014	110385
2011	49108
2010	6047

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2011
2nd row	2010
3rd row	2011
4th row	2010
5th row	2010

Common Values

Value	Count	Frequency (%)
2013	220953	40.4%
2012	159786	29.2%
2014	110385	20.2%
2011	49108	9.0%
2010	6047	1.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
2013	220953	40.4%
2012	159786	29.2%
2014	110385	20.2%
2011	49108	9.0%
2010	6047	1.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

month_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.807395122

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	5
Q3	8
95-th percentile	11
Maximum	12
Range	11
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.064773168
Coefficient of variation (CV)	0.5277362921
Kurtosis	-0.8662793891
Mean	5.807395122
Median Absolute Deviation (MAD)	2
Skewness	0.2756048808
Sum	3172458
Variance	9.392834574
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
5	74443	13.6%
6	70662	12.9%
4	61361	11.2%
3	51150	9.4%
2	45364	8.3%
8	43420	7.9%
1	43221	7.9%
9	40494	7.4%
7	33322	6.1%
10	32057	5.9%
Other values (2)	50785	9.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	43221	7.9%
2	45364	8.3%
3	51150	9.4%
4	61361	11.2%
5	74443	13.6%
6	70662	12.9%
7	33322	6.1%
8	43420	7.9%
9	40494	7.4%
10	32057	5.9%

Value	Count	Frequency (%)
12	19163	3.5%
11	31622	5.8%
10	32057	5.9%
9	40494	7.4%
8	43420	7.9%
7	33322	6.1%
6	70662	12.9%
5	74443	13.6%
4	61361	11.2%
3	51150	9.4%

day_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.51420428

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.426259432
Coefficient of variation (CV)	0.5431319119
Kurtosis	-1.179780674
Mean	15.51420428
Median Absolute Deviation (MAD)	7
Skewness	-0.001108146792
Sum	8475084
Variance	71.00184802
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
24	20025	3.7%
22	19978	3.7%
23	19644	3.6%
27	19491	3.6%
16	19380	3.5%
13	19380	3.5%
3	19254	3.5%
15	19070	3.5%
10	18986	3.5%
9	18876	3.5%
Other values (21)	352195	64.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	12800	2.3%
2	16128	3.0%
3	19254	3.5%
4	18663	3.4%
5	18659	3.4%
6	18378	3.4%
7	18635	3.4%
8	18547	3.4%
9	18876	3.5%
10	18986	3.5%

Value	Count	Frequency (%)
31	2842	0.5%
30	11307	2.1%
29	14621	2.7%
28	17435	3.2%
27	19491	3.6%
26	18169	3.3%
25	18743	3.4%
24	20025	3.7%
23	19644	3.6%
22	19978	3.7%

day_of_week_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.442533943

Minimum	0
Maximum	6
Zeros	85435
Zeros (%)	15.6%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	4
95-th percentile	5
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.732170097
Coefficient of variation (CV)	0.7091693042
Kurtosis	-0.9214786044
Mean	2.442533943
Median Absolute Deviation (MAD)	1
Skewness	0.2732217998
Sum	1334305
Variance	3.000413245
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	105409	19.3%
1	103329	18.9%
3	93136	17.0%
0	85435	15.6%
4	77903	14.3%
5	57264	10.5%
6	23803	4.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	85435	15.6%
1	103329	18.9%
2	105409	19.3%
3	93136	17.0%
4	77903	14.3%
5	57264	10.5%
6	23803	4.4%

Value	Count	Frequency (%)
6	23803	4.4%
5	57264	10.5%
4	77903	14.3%
3	93136	17.0%
2	105409	19.3%
1	103329	18.9%
0	85435	15.6%

week_of_year_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.02836097

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	14
median	23
Q3	34
95-th percentile	48
Maximum	53
Range	52
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	13.29918669
Coefficient of variation (CV)	0.5534787292
Kurtosis	-0.8720709604
Mean	24.02836097
Median Absolute Deviation (MAD)	10
Skewness	0.2745425759
Sum	13126189
Variance	176.8683667
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23	18589	3.4%
21	17345	3.2%
25	17014	3.1%
19	16951	3.1%
20	16931	3.1%
24	16914	3.1%
26	16794	3.1%
18	15518	2.8%
22	15362	2.8%
17	14928	2.7%
Other values (43)	379933	69.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5766	1.1%
2	6396	1.2%
3	9917	1.8%
4	10172	1.9%
5	9368	1.7%
6	11326	2.1%
7	11288	2.1%
8	11461	2.1%
9	11265	2.1%
10	11786	2.2%

Value	Count	Frequency (%)
53	2	< 0.1%
52	3263	0.6%
51	5132	0.9%
50	6160	1.1%
49	6994	1.3%
48	6226	1.1%
47	7460	1.4%
46	8165	1.5%
45	8016	1.5%
44	6757	1.2%

gender
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

FEMALE	243211
MALE	216842
-unknown-	84626
OTHER	1600

Length

Max length	9
Median length	6
Mean length	5.667924266
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MALE
2nd row	FEMALE
3rd row	FEMALE
4th row	-unknown-
5th row	FEMALE

Common Values

Value	Count	Frequency (%)
FEMALE	243211	44.5%
MALE	216842	39.7%
-unknown-	84626	15.5%
OTHER	1600	0.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
female	243211	44.5%
male	216842	39.7%
unknown	84626	15.5%
other	1600	0.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

signup_method
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

basic	342438
facebook	203334
google	507

Length

Max length	8
Median length	5
Mean length	6.117577282
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	facebook
2nd row	basic
3rd row	facebook
4th row	basic
5th row	basic

Common Values

Value	Count	Frequency (%)
basic	342438	62.7%
facebook	203334	37.2%
google	507	0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
basic	342438	62.7%
facebook	203334	37.2%
google	507	0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

language
Categorical

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

en	531343
fr	3510
es	2500
de	2362
zh	1761
Other values (20)	4803

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	en
2nd row	en
3rd row	en
4th row	en
5th row	en

Common Values

Value	Count	Frequency (%)
en	531343	97.3%
fr	3510	0.6%
es	2500	0.5%
de	2362	0.4%
zh	1761	0.3%
it	1037	0.2%
ko	975	0.2%
ru	686	0.1%
nl	386	0.1%
pt	380	0.1%
Other values (15)	1339	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
en	531343	97.3%
fr	3510	0.6%
es	2500	0.5%
de	2362	0.4%
zh	1761	0.3%
it	1037	0.2%
ko	975	0.2%
ru	686	0.1%
nl	386	0.1%
pt	380	0.1%
Other values (15)	1339	0.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

affiliate_channel
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

direct	363423
sem-brand	72963
sem-non-brand	47509
seo	24159
other	15986
Other values (3)	22239

Length

Max length	13
Median length	6
Mean length	6.806657404
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	seo
2nd row	direct
3rd row	direct
4th row	direct
5th row	other

Common Values

Value	Count	Frequency (%)
direct	363423	66.5%
sem-brand	72963	13.4%
sem-non-brand	47509	8.7%
seo	24159	4.4%
other	15986	2.9%
api	13862	2.5%
content	5657	1.0%
remarketing	2720	0.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
direct	363423	66.5%
sem-brand	72963	13.4%
sem-non-brand	47509	8.7%
seo	24159	4.4%
other	15986	2.9%
api	13862	2.5%
content	5657	1.0%
remarketing	2720	0.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

affiliate_provider
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

direct	362413
google	137094
other	22322
facebook	6818
craigslist	6206
Other values (12)	11426

Length

Max length	19
Median length	6
Mean length	6.051290641
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	google
2nd row	direct
3rd row	direct
4th row	direct
5th row	craigslist

Common Values

Value	Count	Frequency (%)
direct	362413	66.3%
google	137094	25.1%
other	22322	4.1%
facebook	6818	1.2%
craigslist	6206	1.1%
bing	5613	1.0%
facebook-open-graph	1716	0.3%
vast	1296	0.2%
padmapper	967	0.2%
yahoo	739	0.1%
Other values (7)	1095	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
direct	362413	66.3%
google	137094	25.1%
other	22322	4.1%
facebook	6818	1.2%
craigslist	6206	1.1%
bing	5613	1.0%
facebook-open-graph	1716	0.3%
vast	1296	0.2%
padmapper	967	0.2%
yahoo	739	0.1%
Other values (7)	1095	0.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

first_affiliate_tracked
Categorical

HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

untracked	298351
linked	120133
omg	111276
tracked-other	12357
product	3842
Other values (2)	320

Length

Max length	13
Median length	9
Mean length	7.194492192
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	untracked
2nd row	untracked
3rd row	untracked
4th row	untracked
5th row	untracked

Common Values

Value	Count	Frequency (%)
untracked	298351	54.6%
linked	120133	22.0%
omg	111276	20.4%
tracked-other	12357	2.3%
product	3842	0.7%
marketing	243	< 0.1%
local ops	77	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
untracked	298351	54.6%
linked	120133	22.0%
omg	111276	20.4%
tracked-other	12357	2.3%
product	3842	0.7%
marketing	243	< 0.1%
local	77	< 0.1%
ops	77	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

signup_app
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Web	504897
iOS	27946
Moweb	7662
Android	5774

Length

Max length	7
Median length	3
Mean length	3.070330362
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Web
2nd row	Web
3rd row	Web
4th row	Web
5th row	Web

Common Values

Value	Count	Frequency (%)
Web	504897	92.4%
iOS	27946	5.1%
Moweb	7662	1.4%
Android	5774	1.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
web	504897	92.4%
ios	27946	5.1%
moweb	7662	1.4%
android	5774	1.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

first_device_type
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Mac Desktop	282841
Windows Desktop	181356
iPad	34821
iPhone	31998
Other/Unknown	5982
Other values (4)	9281

Length

Max length	18
Median length	11
Mean length	11.66326364
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Mac Desktop
2nd row	Windows Desktop
3rd row	Mac Desktop
4th row	Mac Desktop
5th row	Mac Desktop

Common Values

Value	Count	Frequency (%)
Mac Desktop	282841	51.8%
Windows Desktop	181356	33.2%
iPad	34821	6.4%
iPhone	31998	5.9%
Other/Unknown	5982	1.1%
Desktop (Other)	3596	0.7%
Android Phone	3031	0.6%
Android Tablet	2587	0.5%
SmartPhone (Other)	67	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
desktop	467793	45.9%
mac	282841	27.7%
windows	181356	17.8%
ipad	34821	3.4%
iphone	31998	3.1%
other/unknown	5982	0.6%
android	5618	0.6%
other	3663	0.4%
phone	3031	0.3%
tablet	2587	0.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

first_browser
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	41
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Chrome	191007
Safari	133717
Firefox	98677
IE	44859
Mobile Safari	42069
Other values (36)	35950

Length

Max length	18
Median length	6
Mean length	6.614079985
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	Chrome
2nd row	IE
3rd row	Firefox
4th row	Chrome
5th row	Safari

Common Values

Value	Count	Frequency (%)
Chrome	191007	35.0%
Safari	133717	24.5%
Firefox	98677	18.1%
IE	44859	8.2%
Mobile Safari	42069	7.7%
-unknown-	30873	5.7%
Chrome Mobile	2131	0.4%
Android Browser	1124	0.2%
Opera	419	0.1%
Chromium	273	< 0.1%
Other values (31)	1130	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
chrome	193138	32.6%
safari	175786	29.7%
firefox	98716	16.7%
ie	44872	7.6%
mobile	44254	7.5%
unknown	30873	5.2%
browser	1218	0.2%
android	1124	0.2%
opera	423	0.1%
chromium	273	< 0.1%
Other values (33)	1455	0.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

country_destination
Categorical

HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

NDF	54850
GB	52688
ES	50508
NL	47598
US	47539
Other values (7)	293096

Length

Max length	5
Median length	2
Mean length	2.346165604
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NDF
2nd row	US
3rd row	other
4th row	US
5th row	US

Common Values

Value	Count	Frequency (%)
NDF	54850	10.0%
GB	52688	9.6%
ES	50508	9.2%
NL	47598	8.7%
US	47539	8.7%
PT	47100	8.6%
other	44751	8.2%
FR	43870	8.0%
CA	42542	7.8%
IT	40200	7.4%
Other values (2)	74633	13.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ndf	54850	10.0%
gb	52688	9.6%
es	50508	9.2%
nl	47598	8.7%
us	47539	8.7%
pt	47100	8.6%
other	44751	8.2%
fr	43870	8.0%
ca	42542	7.8%
it	40200	7.4%
Other values (2)	74633	13.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	age	signup_flow	days_from_first_active_until_booking	days_from_first_active_until_account_created	days_from_account_created_until_first_booking	year_first_active	month_first_active	day_first_active	day_of_week_first_active	week_of_year_first_active	year_first_booking	month_first_booking	day_first_booking	day_of_week_first_booking	week_of_year_first_booking	year_account_created	month_account_created	day_account_created	day_of_week_account_created	week_of_year_account_created	gender	signup_method	language	affiliate_channel	affiliate_provider	first_affiliate_tracked	signup_app	first_device_type	first_browser	country_destination
0	38	0	2228	732	1496	2009	5	23	5	21	2015	6	29	0	27	2011	5	25	2	21	MALE	facebook	en	seo	google	untracked	Web	Mac Desktop	Chrome	NDF
1	56	3	419	476	-57	2009	6	9	1	24	2010	8	2	0	31	2010	9	28	1	39	FEMALE	basic	en	direct	direct	untracked	Web	Windows Desktop	IE	US
2	42	0	1043	765	278	2009	10	31	5	44	2012	9	8	5	36	2011	12	5	0	49	FEMALE	facebook	en	direct	direct	untracked	Web	Mac Desktop	Firefox	other
3	41	0	72	280	-208	2009	12	8	1	50	2010	2	18	3	7	2010	9	14	1	37	-unknown-	basic	en	direct	direct	untracked	Web	Mac Desktop	Chrome	US
4	46	0	3	0	3	2010	1	2	5	53	2010	1	5	1	1	2010	1	2	5	53	FEMALE	basic	en	other	craigslist	untracked	Web	Mac Desktop	Safari	US
5	47	0	10	0	10	2010	1	3	6	53	2010	1	13	2	2	2010	1	3	6	53	FEMALE	basic	en	direct	direct	omg	Web	Mac Desktop	Safari	US
6	50	0	206	0	206	2010	1	4	0	1	2010	7	29	3	30	2010	1	4	0	1	FEMALE	basic	en	other	craigslist	untracked	Web	Mac Desktop	Safari	US
7	46	0	0	0	0	2010	1	4	0	1	2010	1	4	0	1	2010	1	4	0	1	-unknown-	basic	en	other	craigslist	omg	Web	Mac Desktop	Firefox	US
8	36	0	2	0	2	2010	1	4	0	1	2010	1	6	2	1	2010	1	4	0	1	FEMALE	basic	en	other	craigslist	untracked	Web	Mac Desktop	Firefox	US
9	47	0	2001	0	2001	2010	1	5	1	1	2015	6	29	0	27	2010	1	5	1	1	FEMALE	basic	en	other	craigslist	untracked	Web	iPhone	-unknown-	NDF

Last rows

	age	signup_flow	days_from_first_active_until_booking	days_from_account_created_until_first_booking	year_first_active	month_first_active	day_first_active	day_of_week_first_active	week_of_year_first_active	year_first_booking	month_first_booking	day_first_booking	day_of_week_first_booking	week_of_year_first_booking	year_account_created	month_account_created	day_account_created	day_of_week_account_created	week_of_year_account_created	gender	signup_method	language	affiliate_channel	affiliate_provider	first_affiliate_tracked	signup_app	first_device_type	first_browser	country_destination
546269	46	0	172	172	2014	1	9	6	5	2014	7	27	2	30	2014	1	9	6	5	MALE	basic	en	direct	direct	untracked	Web	Mac Desktop	Chrome	other
546270	25	0	0	0	2013	12	17	1	51	2013	12	17	1	51	2013	12	17	1	51	MALE	basic	en	sem-brand	google	omg	Web	Windows Desktop	Chrome	other
546271	29	20	73	73	2014	3	4	2	11	2014	5	16	5	21	2014	3	4	2	11	FEMALE	basic	en	direct	direct	untracked	iOS	Mac Desktop	Chrome	other
546272	31	0	1	1	2013	11	19	1	47	2013	11	20	2	47	2013	11	19	1	47	FEMALE	basic	en	sem-non-brand	google	omg	Web	Windows Desktop	Chrome	other
546273	40	0	1	1	2012	10	1	0	40	2012	10	2	2	40	2012	10	1	0	40	FEMALE	basic	en	direct	direct	omg	Web	Mac Desktop	Safari	other
546274	33	0	1	1	2013	3	20	2	12	2013	3	22	4	12	2013	3	20	2	12	FEMALE	basic	en	direct	direct	linked	Web	Mac Desktop	Firefox	other
546275	34	0	52	52	2012	7	7	0	27	2012	8	29	3	35	2012	7	7	0	27	MALE	facebook	en	direct	direct	linked	Web	Windows Desktop	Firefox	other
546276	29	0	22	22	2013	5	21	2	21	2013	6	13	3	24	2013	5	21	2	21	-unknown-	basic	en	direct	direct	untracked	Web	Windows Desktop	IE	other
546277	28	0	2	2	2014	1	13	0	3	2014	1	16	3	3	2014	1	13	0	3	FEMALE	basic	en	direct	direct	linked	Web	Mac Desktop	Safari	other
546278	39	0	1	1	2011	7	22	5	29	2011	7	23	3	29	2011	7	22	5	29	FEMALE	basic	en	direct	direct	untracked	Web	Windows Desktop	Chrome	other

Most frequently occurring

	age	days_from_first_active_until_booking	days_from_account_created_until_first_booking	year_first_active	month_first_active	day_first_active	day_of_week_first_active	week_of_year_first_active	year_first_booking	month_first_booking	day_first_booking	day_of_week_first_booking	week_of_year_first_booking	year_account_created	month_account_created	day_account_created	day_of_week_account_created	week_of_year_account_created	gender	signup_method	language	affiliate_channel	affiliate_provider	first_affiliate_tracked	signup_app	first_device_type	first_browser	country_destination	# duplicates
50458	35	0	0	2013	6	13	5	27	2013	6	13	5	27	2013	6	13	5	27	-unknown-	basic	en	direct	direct	untracked	Web	Mac Desktop	Chrome	PT	89
32942	31	0	0	2013	6	15	5	24	2013	6	15	5	24	2013	6	15	5	24	FEMALE	facebook	en	direct	direct	untracked	Web	Windows Desktop	Chrome	PT	85
42373	33	0	0	2013	6	15	6	24	2013	6	15	6	24	2013	6	15	6	24	-unknown-	basic	en	sem-brand	google	untracked	Web	Windows Desktop	Chrome	PT	68
37723	32	0	0	2013	6	15	5	24	2013	6	15	5	24	2013	6	15	5	24	-unknown-	basic	en	sem-brand	google	untracked	Web	Windows Desktop	Chrome	PT	66
27502	30	0	0	2012	8	14	2	33	2012	8	14	2	33	2012	8	14	2	33	FEMALE	facebook	en	direct	direct	linked	Web	Mac Desktop	Chrome	PT	65
11205	26	0	0	2013	3	4	0	10	2013	3	5	1	10	2013	3	4	0	10	-unknown-	basic	en	direct	direct	untracked	Web	Mac Desktop	Chrome	PT	64
46652	34	0	0	2013	6	15	6	24	2013	6	15	6	24	2013	6	15	6	24	-unknown-	basic	en	direct	direct	linked	Web	Mac Desktop	Firefox	PT	63
8217	25	0	0	2013	3	5	1	10	2013	3	6	2	10	2013	3	5	1	10	MALE	facebook	en	sem-brand	google	omg	Web	Windows Desktop	Chrome	PT	62
43050	33	1	1	2013	10	3	3	40	2013	10	4	4	40	2013	10	3	3	40	MALE	basic	en	direct	direct	untracked	Web	Windows Desktop	Chrome	PT	62
53577	36	0	0	2012	6	18	1	24	2012	6	18	1	24	2012	6	18	1	24	FEMALE	facebook	en	direct	direct	omg	Web	Mac Desktop	Safari	PT	60

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block